﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkOrderService" targetNamespace="http://tempuri.org/CDmDjkOrderService.xsd" xmlns:mstns="http://tempuri.org/CDmDjkOrderService.xsd" xmlns="http://tempuri.org/CDmDjkOrderService.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_ORDER_SERVICETableAdapter" GeneratorDataComponentClassName="DJK_ORDER_SERVICETableAdapter" Name="DJK_ORDER_SERVICE" UserDataComponentName="DJK_ORDER_SERVICETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_ORDER_SERVICE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_ORDER_SERVICE] WHERE (([ORDER_SERVICE_ID] = @Original_ORDER_SERVICE_ID) AND ((@IsNull_ORDER_ROUTE_ID = 1 AND [ORDER_ROUTE_ID] IS NULL) OR ([ORDER_ROUTE_ID] = @Original_ORDER_ROUTE_ID)) AND ((@IsNull_ORDER_ROUTE_NME = 1 AND [ORDER_ROUTE_NME] IS NULL) OR ([ORDER_ROUTE_NME] = @Original_ORDER_ROUTE_NME)) AND ((@IsNull_ORDER_ROUTE_TYPE = 1 AND [ORDER_ROUTE_TYPE] IS NULL) OR ([ORDER_ROUTE_TYPE] = @Original_ORDER_ROUTE_TYPE)) AND ((@IsNull_ORDER_ROUTE_DAYS = 1 AND [ORDER_ROUTE_DAYS] IS NULL) OR ([ORDER_ROUTE_DAYS] = @Original_ORDER_ROUTE_DAYS)) AND ((@IsNull_ORDER_VEHICLE_ID = 1 AND [ORDER_VEHICLE_ID] IS NULL) OR ([ORDER_VEHICLE_ID] = @Original_ORDER_VEHICLE_ID)) AND ((@IsNull_ORDER_VEHICLE_NME = 1 AND [ORDER_VEHICLE_NME] IS NULL) OR ([ORDER_VEHICLE_NME] = @Original_ORDER_VEHICLE_NME)) AND ((@IsNull_ORDER_VEHICLE_SEATS = 1 AND [ORDER_VEHICLE_SEATS] IS NULL) OR ([ORDER_VEHICLE_SEATS] = @Original_ORDER_VEHICLE_SEATS)) AND ((@IsNull_ORDER_VEHICLE_TYPE = 1 AND [ORDER_VEHICLE_TYPE] IS NULL) OR ([ORDER_VEHICLE_TYPE] = @Original_ORDER_VEHICLE_TYPE)) AND ((@IsNull_VEHICLE_TYPE_NME = 1 AND [VEHICLE_TYPE_NME] IS NULL) OR ([VEHICLE_TYPE_NME] = @Original_VEHICLE_TYPE_NME)) AND ((@IsNull_ORDER_VEHICLE_BRAND = 1 AND [ORDER_VEHICLE_BRAND] IS NULL) OR ([ORDER_VEHICLE_BRAND] = @Original_ORDER_VEHICLE_BRAND)) AND ((@IsNull_VEHICLE_BRAND_NME = 1 AND [VEHICLE_BRAND_NME] IS NULL) OR ([VEHICLE_BRAND_NME] = @Original_VEHICLE_BRAND_NME)) AND ((@IsNull_ORDER_DJACK_ID = 1 AND [ORDER_DJACK_ID] IS NULL) OR ([ORDER_DJACK_ID] = @Original_ORDER_DJACK_ID)) AND ((@IsNull_ORDER_DJACK_NME = 1 AND [ORDER_DJACK_NME] IS NULL) OR ([ORDER_DJACK_NME] = @Original_ORDER_DJACK_NME)) AND ((@IsNull_BEGIN_SERVICE_DT = 1 AND [BEGIN_SERVICE_DT] IS NULL) OR ([BEGIN_SERVICE_DT] = @Original_BEGIN_SERVICE_DT)) AND ((@IsNull_BEGIN_SERVICE_ADDR = 1 AND [BEGIN_SERVICE_ADDR] IS NULL) OR ([BEGIN_SERVICE_ADDR] = @Original_BEGIN_SERVICE_ADDR)) AND ((@IsNull_TOTAL_CHARGE = 1 AND [TOTAL_CHARGE] IS NULL) OR ([TOTAL_CHARGE] = @Original_TOTAL_CHARGE)) AND ((@IsNull_ORDER_COMMIT_DT = 1 AND [ORDER_COMMIT_DT] IS NULL) OR ([ORDER_COMMIT_DT] = @Original_ORDER_COMMIT_DT)) AND ((@IsNull_BUYER_NME = 1 AND [BUYER_NME] IS NULL) OR ([BUYER_NME] = @Original_BUYER_NME)) AND ((@IsNull_BUYER_PHONE = 1 AND [BUYER_PHONE] IS NULL) OR ([BUYER_PHONE] = @Original_BUYER_PHONE)) AND ((@IsNull_CREATE_ID = 1 AND [CREATE_ID] IS NULL) OR ([CREATE_ID] = @Original_CREATE_ID)) AND ((@IsNull_CREATE_DT = 1 AND [CREATE_DT] IS NULL) OR ([CREATE_DT] = @Original_CREATE_DT)) AND ((@IsNull_MODIFY_ID = 1 AND [MODIFY_ID] IS NULL) OR ([MODIFY_ID] = @Original_MODIFY_ID)) AND ((@IsNull_MODIFY_DT = 1 AND [MODIFY_DT] IS NULL) OR ([MODIFY_DT] = @Original_MODIFY_DT)) AND ((@IsNull_COUNTRY_ID = 1 AND [COUNTRY_ID] IS NULL) OR ([COUNTRY_ID] = @Original_COUNTRY_ID)) AND ((@IsNull_COUNTRY_NME = 1 AND [COUNTRY_NME] IS NULL) OR ([COUNTRY_NME] = @Original_COUNTRY_NME)) AND ((@IsNull_CITY_ID = 1 AND [CITY_ID] IS NULL) OR ([CITY_ID] = @Original_CITY_ID)) AND ((@IsNull_CITY_NME = 1 AND [CITY_NME] IS NULL) OR ([CITY_NME] = @Original_CITY_NME)) AND ((@IsNull_DESTINATION_ID = 1 AND [DESTINATION_ID] IS NULL) OR ([DESTINATION_ID] = @Original_DESTINATION_ID)) AND ((@IsNull_DESTINATION_NME = 1 AND [DESTINATION_NME] IS NULL) OR ([DESTINATION_NME] = @Original_DESTINATION_NME)) AND ((@IsNull_ORDER_IS_VALID = 1 AND [ORDER_IS_VALID] IS NULL) OR ([ORDER_IS_VALID] = @Original_ORDER_IS_VALID)) AND ((@IsNull_ORDER_ROUTE_STATUS = 1 AND [ORDER_ROUTE_STATUS] IS NULL) OR ([ORDER_ROUTE_STATUS] = @Original_ORDER_ROUTE_STATUS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_SERVICE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_SERVICE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_ROUTE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_SEATS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_SEATS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VEHICLE_TYPE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VEHICLE_TYPE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VEHICLE_TYPE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_TYPE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_BRAND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_BRAND" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_BRAND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_BRAND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VEHICLE_BRAND_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VEHICLE_BRAND_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VEHICLE_BRAND_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_BRAND_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_DJACK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_DJACK_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_DJACK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_DJACK_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_DJACK_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_DJACK_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_DJACK_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_DJACK_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BEGIN_SERVICE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_BEGIN_SERVICE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BEGIN_SERVICE_ADDR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_ADDR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BEGIN_SERVICE_ADDR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_ADDR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TOTAL_CHARGE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TOTAL_CHARGE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TOTAL_CHARGE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TOTAL_CHARGE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_COMMIT_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_COMMIT_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_COMMIT_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_COMMIT_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BUYER_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BUYER_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BUYER_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BUYER_PHONE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BUYER_PHONE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BUYER_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_PHONE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CREATE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MODIFY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COUNTRY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COUNTRY_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COUNTRY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CITY_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESTINATION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DESTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESTINATION_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DESTINATION_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_IS_VALID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_IS_VALID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_ROUTE_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_ORDER_SERVICE] ([ORDER_SERVICE_ID], [ORDER_ROUTE_ID], [ORDER_ROUTE_NME], [ORDER_ROUTE_TYPE], [ORDER_ROUTE_DAYS], [ORDER_VEHICLE_ID], [ORDER_VEHICLE_NME], [ORDER_VEHICLE_SEATS], [ORDER_VEHICLE_TYPE], [VEHICLE_TYPE_NME], [ORDER_VEHICLE_BRAND], [VEHICLE_BRAND_NME], [ORDER_DJACK_ID], [ORDER_DJACK_NME], [BEGIN_SERVICE_DT], [BEGIN_SERVICE_ADDR], [TOTAL_CHARGE], [ORDER_COMMIT_DT], [BUYER_NME], [BUYER_PHONE], [CREATE_ID], [CREATE_DT], [MODIFY_ID], [MODIFY_DT], [COUNTRY_ID], [COUNTRY_NME], [CITY_ID], [CITY_NME], [DESTINATION_ID], [DESTINATION_NME], [ORDER_IS_VALID], [ORDER_ROUTE_STATUS]) VALUES (@ORDER_SERVICE_ID, @ORDER_ROUTE_ID, @ORDER_ROUTE_NME, @ORDER_ROUTE_TYPE, @ORDER_ROUTE_DAYS, @ORDER_VEHICLE_ID, @ORDER_VEHICLE_NME, @ORDER_VEHICLE_SEATS, @ORDER_VEHICLE_TYPE, @VEHICLE_TYPE_NME, @ORDER_VEHICLE_BRAND, @VEHICLE_BRAND_NME, @ORDER_DJACK_ID, @ORDER_DJACK_NME, @BEGIN_SERVICE_DT, @BEGIN_SERVICE_ADDR, @TOTAL_CHARGE, @ORDER_COMMIT_DT, @BUYER_NME, @BUYER_PHONE, @CREATE_ID, @CREATE_DT, @MODIFY_ID, @MODIFY_DT, @COUNTRY_ID, @COUNTRY_NME, @CITY_ID, @CITY_NME, @DESTINATION_ID, @DESTINATION_NME, @ORDER_IS_VALID, @ORDER_ROUTE_STATUS);
SELECT ORDER_SERVICE_ID, ORDER_ROUTE_ID, ORDER_ROUTE_NME, ORDER_ROUTE_TYPE, ORDER_ROUTE_DAYS, ORDER_VEHICLE_ID, ORDER_VEHICLE_NME, ORDER_VEHICLE_SEATS, ORDER_VEHICLE_TYPE, VEHICLE_TYPE_NME, ORDER_VEHICLE_BRAND, VEHICLE_BRAND_NME, ORDER_DJACK_ID, ORDER_DJACK_NME, BEGIN_SERVICE_DT, BEGIN_SERVICE_ADDR, TOTAL_CHARGE, ORDER_COMMIT_DT, BUYER_NME, BUYER_PHONE, CREATE_ID, CREATE_DT, MODIFY_ID, MODIFY_DT, COUNTRY_ID, COUNTRY_NME, CITY_ID, CITY_NME, DESTINATION_ID, DESTINATION_NME, ORDER_IS_VALID, ORDER_ROUTE_STATUS FROM DJK_ORDER_SERVICE WHERE (ORDER_SERVICE_ID = @ORDER_SERVICE_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_SERVICE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_SERVICE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_ROUTE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_VEHICLE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_VEHICLE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_VEHICLE_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_SEATS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_VEHICLE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VEHICLE_TYPE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_TYPE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_VEHICLE_BRAND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_BRAND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VEHICLE_BRAND_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_BRAND_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_DJACK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_DJACK_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_DJACK_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_DJACK_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BEGIN_SERVICE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BEGIN_SERVICE_ADDR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_ADDR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TOTAL_CHARGE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TOTAL_CHARGE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_COMMIT_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_COMMIT_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUYER_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUYER_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CREATE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MODIFY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COUNTRY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESTINATION_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_IS_VALID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_ROUTE_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ORDER_SERVICE_ID, ORDER_ROUTE_ID, ORDER_ROUTE_NME, ORDER_ROUTE_TYPE, ORDER_ROUTE_DAYS, ORDER_VEHICLE_ID, ORDER_VEHICLE_NME, ORDER_VEHICLE_SEATS, ORDER_VEHICLE_TYPE, VEHICLE_TYPE_NME, ORDER_VEHICLE_BRAND, VEHICLE_BRAND_NME, ORDER_DJACK_ID, ORDER_DJACK_NME, BEGIN_SERVICE_DT, BEGIN_SERVICE_ADDR, TOTAL_CHARGE, ORDER_COMMIT_DT, BUYER_NME, BUYER_PHONE, CREATE_ID, CREATE_DT, MODIFY_ID, MODIFY_DT, COUNTRY_ID, COUNTRY_NME, CITY_ID, CITY_NME, DESTINATION_ID, DESTINATION_NME, ORDER_IS_VALID, ORDER_ROUTE_STATUS FROM dbo.DJK_ORDER_SERVICE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_ORDER_SERVICE] SET [ORDER_SERVICE_ID] = @ORDER_SERVICE_ID, [ORDER_ROUTE_ID] = @ORDER_ROUTE_ID, [ORDER_ROUTE_NME] = @ORDER_ROUTE_NME, [ORDER_ROUTE_TYPE] = @ORDER_ROUTE_TYPE, [ORDER_ROUTE_DAYS] = @ORDER_ROUTE_DAYS, [ORDER_VEHICLE_ID] = @ORDER_VEHICLE_ID, [ORDER_VEHICLE_NME] = @ORDER_VEHICLE_NME, [ORDER_VEHICLE_SEATS] = @ORDER_VEHICLE_SEATS, [ORDER_VEHICLE_TYPE] = @ORDER_VEHICLE_TYPE, [VEHICLE_TYPE_NME] = @VEHICLE_TYPE_NME, [ORDER_VEHICLE_BRAND] = @ORDER_VEHICLE_BRAND, [VEHICLE_BRAND_NME] = @VEHICLE_BRAND_NME, [ORDER_DJACK_ID] = @ORDER_DJACK_ID, [ORDER_DJACK_NME] = @ORDER_DJACK_NME, [BEGIN_SERVICE_DT] = @BEGIN_SERVICE_DT, [BEGIN_SERVICE_ADDR] = @BEGIN_SERVICE_ADDR, [TOTAL_CHARGE] = @TOTAL_CHARGE, [ORDER_COMMIT_DT] = @ORDER_COMMIT_DT, [BUYER_NME] = @BUYER_NME, [BUYER_PHONE] = @BUYER_PHONE, [CREATE_ID] = @CREATE_ID, [CREATE_DT] = @CREATE_DT, [MODIFY_ID] = @MODIFY_ID, [MODIFY_DT] = @MODIFY_DT, [COUNTRY_ID] = @COUNTRY_ID, [COUNTRY_NME] = @COUNTRY_NME, [CITY_ID] = @CITY_ID, [CITY_NME] = @CITY_NME, [DESTINATION_ID] = @DESTINATION_ID, [DESTINATION_NME] = @DESTINATION_NME, [ORDER_IS_VALID] = @ORDER_IS_VALID, [ORDER_ROUTE_STATUS] = @ORDER_ROUTE_STATUS WHERE (([ORDER_SERVICE_ID] = @Original_ORDER_SERVICE_ID) AND ((@IsNull_ORDER_ROUTE_ID = 1 AND [ORDER_ROUTE_ID] IS NULL) OR ([ORDER_ROUTE_ID] = @Original_ORDER_ROUTE_ID)) AND ((@IsNull_ORDER_ROUTE_NME = 1 AND [ORDER_ROUTE_NME] IS NULL) OR ([ORDER_ROUTE_NME] = @Original_ORDER_ROUTE_NME)) AND ((@IsNull_ORDER_ROUTE_TYPE = 1 AND [ORDER_ROUTE_TYPE] IS NULL) OR ([ORDER_ROUTE_TYPE] = @Original_ORDER_ROUTE_TYPE)) AND ((@IsNull_ORDER_ROUTE_DAYS = 1 AND [ORDER_ROUTE_DAYS] IS NULL) OR ([ORDER_ROUTE_DAYS] = @Original_ORDER_ROUTE_DAYS)) AND ((@IsNull_ORDER_VEHICLE_ID = 1 AND [ORDER_VEHICLE_ID] IS NULL) OR ([ORDER_VEHICLE_ID] = @Original_ORDER_VEHICLE_ID)) AND ((@IsNull_ORDER_VEHICLE_NME = 1 AND [ORDER_VEHICLE_NME] IS NULL) OR ([ORDER_VEHICLE_NME] = @Original_ORDER_VEHICLE_NME)) AND ((@IsNull_ORDER_VEHICLE_SEATS = 1 AND [ORDER_VEHICLE_SEATS] IS NULL) OR ([ORDER_VEHICLE_SEATS] = @Original_ORDER_VEHICLE_SEATS)) AND ((@IsNull_ORDER_VEHICLE_TYPE = 1 AND [ORDER_VEHICLE_TYPE] IS NULL) OR ([ORDER_VEHICLE_TYPE] = @Original_ORDER_VEHICLE_TYPE)) AND ((@IsNull_VEHICLE_TYPE_NME = 1 AND [VEHICLE_TYPE_NME] IS NULL) OR ([VEHICLE_TYPE_NME] = @Original_VEHICLE_TYPE_NME)) AND ((@IsNull_ORDER_VEHICLE_BRAND = 1 AND [ORDER_VEHICLE_BRAND] IS NULL) OR ([ORDER_VEHICLE_BRAND] = @Original_ORDER_VEHICLE_BRAND)) AND ((@IsNull_VEHICLE_BRAND_NME = 1 AND [VEHICLE_BRAND_NME] IS NULL) OR ([VEHICLE_BRAND_NME] = @Original_VEHICLE_BRAND_NME)) AND ((@IsNull_ORDER_DJACK_ID = 1 AND [ORDER_DJACK_ID] IS NULL) OR ([ORDER_DJACK_ID] = @Original_ORDER_DJACK_ID)) AND ((@IsNull_ORDER_DJACK_NME = 1 AND [ORDER_DJACK_NME] IS NULL) OR ([ORDER_DJACK_NME] = @Original_ORDER_DJACK_NME)) AND ((@IsNull_BEGIN_SERVICE_DT = 1 AND [BEGIN_SERVICE_DT] IS NULL) OR ([BEGIN_SERVICE_DT] = @Original_BEGIN_SERVICE_DT)) AND ((@IsNull_BEGIN_SERVICE_ADDR = 1 AND [BEGIN_SERVICE_ADDR] IS NULL) OR ([BEGIN_SERVICE_ADDR] = @Original_BEGIN_SERVICE_ADDR)) AND ((@IsNull_TOTAL_CHARGE = 1 AND [TOTAL_CHARGE] IS NULL) OR ([TOTAL_CHARGE] = @Original_TOTAL_CHARGE)) AND ((@IsNull_ORDER_COMMIT_DT = 1 AND [ORDER_COMMIT_DT] IS NULL) OR ([ORDER_COMMIT_DT] = @Original_ORDER_COMMIT_DT)) AND ((@IsNull_BUYER_NME = 1 AND [BUYER_NME] IS NULL) OR ([BUYER_NME] = @Original_BUYER_NME)) AND ((@IsNull_BUYER_PHONE = 1 AND [BUYER_PHONE] IS NULL) OR ([BUYER_PHONE] = @Original_BUYER_PHONE)) AND ((@IsNull_CREATE_ID = 1 AND [CREATE_ID] IS NULL) OR ([CREATE_ID] = @Original_CREATE_ID)) AND ((@IsNull_CREATE_DT = 1 AND [CREATE_DT] IS NULL) OR ([CREATE_DT] = @Original_CREATE_DT)) AND ((@IsNull_MODIFY_ID = 1 AND [MODIFY_ID] IS NULL) OR ([MODIFY_ID] = @Original_MODIFY_ID)) AND ((@IsNull_MODIFY_DT = 1 AND [MODIFY_DT] IS NULL) OR ([MODIFY_DT] = @Original_MODIFY_DT)) AND ((@IsNull_COUNTRY_ID = 1 AND [COUNTRY_ID] IS NULL) OR ([COUNTRY_ID] = @Original_COUNTRY_ID)) AND ((@IsNull_COUNTRY_NME = 1 AND [COUNTRY_NME] IS NULL) OR ([COUNTRY_NME] = @Original_COUNTRY_NME)) AND ((@IsNull_CITY_ID = 1 AND [CITY_ID] IS NULL) OR ([CITY_ID] = @Original_CITY_ID)) AND ((@IsNull_CITY_NME = 1 AND [CITY_NME] IS NULL) OR ([CITY_NME] = @Original_CITY_NME)) AND ((@IsNull_DESTINATION_ID = 1 AND [DESTINATION_ID] IS NULL) OR ([DESTINATION_ID] = @Original_DESTINATION_ID)) AND ((@IsNull_DESTINATION_NME = 1 AND [DESTINATION_NME] IS NULL) OR ([DESTINATION_NME] = @Original_DESTINATION_NME)) AND ((@IsNull_ORDER_IS_VALID = 1 AND [ORDER_IS_VALID] IS NULL) OR ([ORDER_IS_VALID] = @Original_ORDER_IS_VALID)) AND ((@IsNull_ORDER_ROUTE_STATUS = 1 AND [ORDER_ROUTE_STATUS] IS NULL) OR ([ORDER_ROUTE_STATUS] = @Original_ORDER_ROUTE_STATUS)));
SELECT ORDER_SERVICE_ID, ORDER_ROUTE_ID, ORDER_ROUTE_NME, ORDER_ROUTE_TYPE, ORDER_ROUTE_DAYS, ORDER_VEHICLE_ID, ORDER_VEHICLE_NME, ORDER_VEHICLE_SEATS, ORDER_VEHICLE_TYPE, VEHICLE_TYPE_NME, ORDER_VEHICLE_BRAND, VEHICLE_BRAND_NME, ORDER_DJACK_ID, ORDER_DJACK_NME, BEGIN_SERVICE_DT, BEGIN_SERVICE_ADDR, TOTAL_CHARGE, ORDER_COMMIT_DT, BUYER_NME, BUYER_PHONE, CREATE_ID, CREATE_DT, MODIFY_ID, MODIFY_DT, COUNTRY_ID, COUNTRY_NME, CITY_ID, CITY_NME, DESTINATION_ID, DESTINATION_NME, ORDER_IS_VALID, ORDER_ROUTE_STATUS FROM DJK_ORDER_SERVICE WHERE (ORDER_SERVICE_ID = @ORDER_SERVICE_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_SERVICE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_SERVICE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_ROUTE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_VEHICLE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_VEHICLE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_VEHICLE_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_SEATS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_VEHICLE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VEHICLE_TYPE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_TYPE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_VEHICLE_BRAND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_BRAND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VEHICLE_BRAND_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_BRAND_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_DJACK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_DJACK_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_DJACK_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_DJACK_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BEGIN_SERVICE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BEGIN_SERVICE_ADDR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_ADDR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TOTAL_CHARGE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TOTAL_CHARGE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_COMMIT_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_COMMIT_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUYER_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUYER_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CREATE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MODIFY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COUNTRY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESTINATION_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_IS_VALID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_ROUTE_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_SERVICE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_SERVICE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_ROUTE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_SEATS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_SEATS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VEHICLE_TYPE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VEHICLE_TYPE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VEHICLE_TYPE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_TYPE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_BRAND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_BRAND" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_BRAND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_BRAND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VEHICLE_BRAND_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VEHICLE_BRAND_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VEHICLE_BRAND_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_BRAND_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_DJACK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_DJACK_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_DJACK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_DJACK_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_DJACK_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_DJACK_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_DJACK_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_DJACK_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BEGIN_SERVICE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_BEGIN_SERVICE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BEGIN_SERVICE_ADDR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_ADDR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BEGIN_SERVICE_ADDR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BEGIN_SERVICE_ADDR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TOTAL_CHARGE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TOTAL_CHARGE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TOTAL_CHARGE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TOTAL_CHARGE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_COMMIT_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_COMMIT_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_COMMIT_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_COMMIT_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BUYER_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BUYER_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BUYER_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BUYER_PHONE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BUYER_PHONE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BUYER_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_PHONE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CREATE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MODIFY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COUNTRY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COUNTRY_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COUNTRY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CITY_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESTINATION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DESTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESTINATION_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DESTINATION_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_IS_VALID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_IS_VALID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_ROUTE_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ORDER_SERVICE_ID" DataSetColumn="ORDER_SERVICE_ID" />
              <Mapping SourceColumn="ORDER_ROUTE_ID" DataSetColumn="ORDER_ROUTE_ID" />
              <Mapping SourceColumn="ORDER_ROUTE_NME" DataSetColumn="ORDER_ROUTE_NME" />
              <Mapping SourceColumn="ORDER_ROUTE_TYPE" DataSetColumn="ORDER_ROUTE_TYPE" />
              <Mapping SourceColumn="ORDER_ROUTE_DAYS" DataSetColumn="ORDER_ROUTE_DAYS" />
              <Mapping SourceColumn="ORDER_VEHICLE_ID" DataSetColumn="ORDER_VEHICLE_ID" />
              <Mapping SourceColumn="ORDER_VEHICLE_NME" DataSetColumn="ORDER_VEHICLE_NME" />
              <Mapping SourceColumn="ORDER_VEHICLE_SEATS" DataSetColumn="ORDER_VEHICLE_SEATS" />
              <Mapping SourceColumn="ORDER_VEHICLE_TYPE" DataSetColumn="ORDER_VEHICLE_TYPE" />
              <Mapping SourceColumn="VEHICLE_TYPE_NME" DataSetColumn="VEHICLE_TYPE_NME" />
              <Mapping SourceColumn="ORDER_VEHICLE_BRAND" DataSetColumn="ORDER_VEHICLE_BRAND" />
              <Mapping SourceColumn="VEHICLE_BRAND_NME" DataSetColumn="VEHICLE_BRAND_NME" />
              <Mapping SourceColumn="ORDER_DJACK_ID" DataSetColumn="ORDER_DJACK_ID" />
              <Mapping SourceColumn="ORDER_DJACK_NME" DataSetColumn="ORDER_DJACK_NME" />
              <Mapping SourceColumn="BEGIN_SERVICE_DT" DataSetColumn="BEGIN_SERVICE_DT" />
              <Mapping SourceColumn="BEGIN_SERVICE_ADDR" DataSetColumn="BEGIN_SERVICE_ADDR" />
              <Mapping SourceColumn="TOTAL_CHARGE" DataSetColumn="TOTAL_CHARGE" />
              <Mapping SourceColumn="ORDER_COMMIT_DT" DataSetColumn="ORDER_COMMIT_DT" />
              <Mapping SourceColumn="BUYER_NME" DataSetColumn="BUYER_NME" />
              <Mapping SourceColumn="BUYER_PHONE" DataSetColumn="BUYER_PHONE" />
              <Mapping SourceColumn="CREATE_ID" DataSetColumn="CREATE_ID" />
              <Mapping SourceColumn="CREATE_DT" DataSetColumn="CREATE_DT" />
              <Mapping SourceColumn="MODIFY_ID" DataSetColumn="MODIFY_ID" />
              <Mapping SourceColumn="MODIFY_DT" DataSetColumn="MODIFY_DT" />
              <Mapping SourceColumn="COUNTRY_ID" DataSetColumn="COUNTRY_ID" />
              <Mapping SourceColumn="COUNTRY_NME" DataSetColumn="COUNTRY_NME" />
              <Mapping SourceColumn="CITY_ID" DataSetColumn="CITY_ID" />
              <Mapping SourceColumn="CITY_NME" DataSetColumn="CITY_NME" />
              <Mapping SourceColumn="DESTINATION_ID" DataSetColumn="DESTINATION_ID" />
              <Mapping SourceColumn="DESTINATION_NME" DataSetColumn="DESTINATION_NME" />
              <Mapping SourceColumn="ORDER_IS_VALID" DataSetColumn="ORDER_IS_VALID" />
              <Mapping SourceColumn="ORDER_ROUTE_STATUS" DataSetColumn="ORDER_ROUTE_STATUS" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkOrderService" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkOrderService" msprop:Generator_UserDSName="CDmDjkOrderService">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_ORDER_SERVICE" msprop:Generator_TableClassName="DJK_ORDER_SERVICEDataTable" msprop:Generator_TableVarName="tableDJK_ORDER_SERVICE" msprop:Generator_TablePropName="DJK_ORDER_SERVICE" msprop:Generator_RowDeletingName="DJK_ORDER_SERVICERowDeleting" msprop:Generator_RowChangingName="DJK_ORDER_SERVICERowChanging" msprop:Generator_RowEvHandlerName="DJK_ORDER_SERVICERowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_ORDER_SERVICERowDeleted" msprop:Generator_UserTableName="DJK_ORDER_SERVICE" msprop:Generator_RowChangedName="DJK_ORDER_SERVICERowChanged" msprop:Generator_RowEvArgName="DJK_ORDER_SERVICERowChangeEvent" msprop:Generator_RowClassName="DJK_ORDER_SERVICERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ORDER_SERVICE_ID" msprop:Generator_ColumnVarNameInTable="columnORDER_SERVICE_ID" msprop:Generator_ColumnPropNameInRow="ORDER_SERVICE_ID" msprop:Generator_ColumnPropNameInTable="ORDER_SERVICE_IDColumn" msprop:Generator_UserColumnName="ORDER_SERVICE_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_ROUTE_ID" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_ID" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_ID" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_IDColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_ROUTE_NME" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_NME" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_NME" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_NMEColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_ROUTE_TYPE" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_TYPE" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_TYPE" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_TYPEColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_TYPE" type="xs:int" minOccurs="0" />
              <xs:element name="ORDER_ROUTE_DAYS" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_DAYS" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_DAYS" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_DAYSColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_DAYS" type="xs:int" minOccurs="0" />
              <xs:element name="ORDER_VEHICLE_ID" msprop:Generator_ColumnVarNameInTable="columnORDER_VEHICLE_ID" msprop:Generator_ColumnPropNameInRow="ORDER_VEHICLE_ID" msprop:Generator_ColumnPropNameInTable="ORDER_VEHICLE_IDColumn" msprop:Generator_UserColumnName="ORDER_VEHICLE_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_VEHICLE_NME" msprop:Generator_ColumnVarNameInTable="columnORDER_VEHICLE_NME" msprop:Generator_ColumnPropNameInRow="ORDER_VEHICLE_NME" msprop:Generator_ColumnPropNameInTable="ORDER_VEHICLE_NMEColumn" msprop:Generator_UserColumnName="ORDER_VEHICLE_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_VEHICLE_SEATS" msprop:Generator_ColumnVarNameInTable="columnORDER_VEHICLE_SEATS" msprop:Generator_ColumnPropNameInRow="ORDER_VEHICLE_SEATS" msprop:Generator_ColumnPropNameInTable="ORDER_VEHICLE_SEATSColumn" msprop:Generator_UserColumnName="ORDER_VEHICLE_SEATS" type="xs:int" minOccurs="0" />
              <xs:element name="ORDER_VEHICLE_TYPE" msprop:Generator_ColumnVarNameInTable="columnORDER_VEHICLE_TYPE" msprop:Generator_ColumnPropNameInRow="ORDER_VEHICLE_TYPE" msprop:Generator_ColumnPropNameInTable="ORDER_VEHICLE_TYPEColumn" msprop:Generator_UserColumnName="ORDER_VEHICLE_TYPE" type="xs:int" minOccurs="0" />
              <xs:element name="VEHICLE_TYPE_NME" msprop:Generator_ColumnVarNameInTable="columnVEHICLE_TYPE_NME" msprop:Generator_ColumnPropNameInRow="VEHICLE_TYPE_NME" msprop:Generator_ColumnPropNameInTable="VEHICLE_TYPE_NMEColumn" msprop:Generator_UserColumnName="VEHICLE_TYPE_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_VEHICLE_BRAND" msprop:Generator_ColumnVarNameInTable="columnORDER_VEHICLE_BRAND" msprop:Generator_ColumnPropNameInRow="ORDER_VEHICLE_BRAND" msprop:Generator_ColumnPropNameInTable="ORDER_VEHICLE_BRANDColumn" msprop:Generator_UserColumnName="ORDER_VEHICLE_BRAND" type="xs:int" minOccurs="0" />
              <xs:element name="VEHICLE_BRAND_NME" msprop:Generator_ColumnVarNameInTable="columnVEHICLE_BRAND_NME" msprop:Generator_ColumnPropNameInRow="VEHICLE_BRAND_NME" msprop:Generator_ColumnPropNameInTable="VEHICLE_BRAND_NMEColumn" msprop:Generator_UserColumnName="VEHICLE_BRAND_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_DJACK_ID" msprop:Generator_ColumnVarNameInTable="columnORDER_DJACK_ID" msprop:Generator_ColumnPropNameInRow="ORDER_DJACK_ID" msprop:Generator_ColumnPropNameInTable="ORDER_DJACK_IDColumn" msprop:Generator_UserColumnName="ORDER_DJACK_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_DJACK_NME" msprop:Generator_ColumnVarNameInTable="columnORDER_DJACK_NME" msprop:Generator_ColumnPropNameInRow="ORDER_DJACK_NME" msprop:Generator_ColumnPropNameInTable="ORDER_DJACK_NMEColumn" msprop:Generator_UserColumnName="ORDER_DJACK_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BEGIN_SERVICE_DT" msprop:Generator_ColumnVarNameInTable="columnBEGIN_SERVICE_DT" msprop:Generator_ColumnPropNameInRow="BEGIN_SERVICE_DT" msprop:Generator_ColumnPropNameInTable="BEGIN_SERVICE_DTColumn" msprop:Generator_UserColumnName="BEGIN_SERVICE_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BEGIN_SERVICE_ADDR" msprop:Generator_ColumnVarNameInTable="columnBEGIN_SERVICE_ADDR" msprop:Generator_ColumnPropNameInRow="BEGIN_SERVICE_ADDR" msprop:Generator_ColumnPropNameInTable="BEGIN_SERVICE_ADDRColumn" msprop:Generator_UserColumnName="BEGIN_SERVICE_ADDR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TOTAL_CHARGE" msprop:Generator_ColumnVarNameInTable="columnTOTAL_CHARGE" msprop:Generator_ColumnPropNameInRow="TOTAL_CHARGE" msprop:Generator_ColumnPropNameInTable="TOTAL_CHARGEColumn" msprop:Generator_UserColumnName="TOTAL_CHARGE" type="xs:decimal" minOccurs="0" />
              <xs:element name="ORDER_COMMIT_DT" msprop:Generator_ColumnVarNameInTable="columnORDER_COMMIT_DT" msprop:Generator_ColumnPropNameInRow="ORDER_COMMIT_DT" msprop:Generator_ColumnPropNameInTable="ORDER_COMMIT_DTColumn" msprop:Generator_UserColumnName="ORDER_COMMIT_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BUYER_NME" msprop:Generator_ColumnVarNameInTable="columnBUYER_NME" msprop:Generator_ColumnPropNameInRow="BUYER_NME" msprop:Generator_ColumnPropNameInTable="BUYER_NMEColumn" msprop:Generator_UserColumnName="BUYER_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BUYER_PHONE" msprop:Generator_ColumnVarNameInTable="columnBUYER_PHONE" msprop:Generator_ColumnPropNameInRow="BUYER_PHONE" msprop:Generator_ColumnPropNameInTable="BUYER_PHONEColumn" msprop:Generator_UserColumnName="BUYER_PHONE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CREATE_ID" msprop:Generator_ColumnVarNameInTable="columnCREATE_ID" msprop:Generator_ColumnPropNameInRow="CREATE_ID" msprop:Generator_ColumnPropNameInTable="CREATE_IDColumn" msprop:Generator_UserColumnName="CREATE_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CREATE_DT" msprop:Generator_ColumnVarNameInTable="columnCREATE_DT" msprop:Generator_ColumnPropNameInRow="CREATE_DT" msprop:Generator_ColumnPropNameInTable="CREATE_DTColumn" msprop:Generator_UserColumnName="CREATE_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFY_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFY_ID" msprop:Generator_ColumnPropNameInRow="MODIFY_ID" msprop:Generator_ColumnPropNameInTable="MODIFY_IDColumn" msprop:Generator_UserColumnName="MODIFY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MODIFY_DT" msprop:Generator_ColumnVarNameInTable="columnMODIFY_DT" msprop:Generator_ColumnPropNameInRow="MODIFY_DT" msprop:Generator_ColumnPropNameInTable="MODIFY_DTColumn" msprop:Generator_UserColumnName="MODIFY_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="COUNTRY_ID" msprop:Generator_ColumnVarNameInTable="columnCOUNTRY_ID" msprop:Generator_ColumnPropNameInRow="COUNTRY_ID" msprop:Generator_ColumnPropNameInTable="COUNTRY_IDColumn" msprop:Generator_UserColumnName="COUNTRY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COUNTRY_NME" msprop:Generator_ColumnVarNameInTable="columnCOUNTRY_NME" msprop:Generator_ColumnPropNameInRow="COUNTRY_NME" msprop:Generator_ColumnPropNameInTable="COUNTRY_NMEColumn" msprop:Generator_UserColumnName="COUNTRY_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CITY_ID" msprop:Generator_ColumnVarNameInTable="columnCITY_ID" msprop:Generator_ColumnPropNameInRow="CITY_ID" msprop:Generator_ColumnPropNameInTable="CITY_IDColumn" msprop:Generator_UserColumnName="CITY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CITY_NME" msprop:Generator_ColumnVarNameInTable="columnCITY_NME" msprop:Generator_ColumnPropNameInRow="CITY_NME" msprop:Generator_ColumnPropNameInTable="CITY_NMEColumn" msprop:Generator_UserColumnName="CITY_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESTINATION_ID" msprop:Generator_ColumnVarNameInTable="columnDESTINATION_ID" msprop:Generator_ColumnPropNameInRow="DESTINATION_ID" msprop:Generator_ColumnPropNameInTable="DESTINATION_IDColumn" msprop:Generator_UserColumnName="DESTINATION_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESTINATION_NME" msprop:Generator_ColumnVarNameInTable="columnDESTINATION_NME" msprop:Generator_ColumnPropNameInRow="DESTINATION_NME" msprop:Generator_ColumnPropNameInTable="DESTINATION_NMEColumn" msprop:Generator_UserColumnName="DESTINATION_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_IS_VALID" msprop:Generator_ColumnVarNameInTable="columnORDER_IS_VALID" msprop:Generator_ColumnPropNameInRow="ORDER_IS_VALID" msprop:Generator_ColumnPropNameInTable="ORDER_IS_VALIDColumn" msprop:Generator_UserColumnName="ORDER_IS_VALID" type="xs:int" minOccurs="0" />
              <xs:element name="ORDER_ROUTE_STATUS" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_STATUS" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_STATUS" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_STATUSColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_STATUS" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_ORDER_SERVICE" />
      <xs:field xpath="mstns:ORDER_SERVICE_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>